iLoADER

HOME

Data Transformation commands

Use the commands defined in this section in the Data Transformation script file.

Data Transformation script

There are several different field types that can be constructed as part of the Data Transformation Script File. Each of these is described in alphabetic order below.

Splitting Data Transformation entries

It is possible to split Data Transformation actions that end with an expression or SQL statement across several lines of text, as long as the first line contains the open brace "{" and the last line contains the close brace "}", for example:

EXPRESSION, [DEMO].[TABLE],My expression, {

If(Field1 = "Y") then

Field2

Else

Field3

Endif}

  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice